CREATE TABLE "ARCHIVE"."WORKFLOW_MESSAGESTATUS" 
   (	"STATUSID" NUMBER(*,0), 
	    "TABLEID" NUMBER(*,0), 
      "STATUSNAME" VARCHAR2(30)
   )
   
CREATE TABLE "ARCHIVE"."WORKFLOW_OPERATELOG" 
   (	"OPERATELOGID" NVARCHAR2(50), 
    	"OPERATETIME" DATE, 
    	"TABLEID" NUMBER(*,0), 
    	"RECORDID" NVARCHAR2(50), 
    	"OPERATEID" NUMBER(*,0), 
    	"COMMENTMESSAGE" VARCHAR2(200), 
    	"FROMSTATUSID" NUMBER(*,0), 
    	"TOSTATUSID" NUMBER(*,0), 
    	"FROMUSERID" NVARCHAR2(50), 
    	"TOUSERID" NVARCHAR2(50), 
    	"SIGNUSERID" NVARCHAR2(50), 
    	"SIGNTIME" DATE, 
    	"ISLAST" NUMBER(*,0)
   )
   
CREATE TABLE "ARCHIVE"."WORKFLOW_OPERATERULE" 
   (	"OPERATEID" NUMBER(*,0) NOT NULL ENABLE, 
    	"OPERATETYPE" NUMBER(*,0), 
    	"OPERATENAME" VARCHAR2(100) NOT NULL ENABLE, 
    	"FROMSTATUSID" NUMBER(*,0) NOT NULL ENABLE, 
    	"TOSTATUSID" NUMBER(*,0) NOT NULL ENABLE, 
    	"TOROLEID" NUMBER(*,0), 
    	"FROMROLEID" NUMBER(*,0)
   )
   
CREATE TABLE "ARCHIVE"."WORKFLOW_TABLE" 
   (	"TABLEID" NUMBER(*,0), 
    	"TABLENAME" NVARCHAR2(50), 
    	"TABLEDESC" NVARCHAR2(50), 
    	"DEFAULTSTATUSID" NUMBER(*,0)
   )